package org.lzz.mapper;

import org.apache.ibatis.annotations.*;
import org.lzz.pojo.Article;

import java.util.List;

@Mapper
public interface ArticleMapper {
    // 新增文章
    @Insert("insert into article(title, content, cover_img, category_id,state, create_user, create_time, update_time) " +
            "values(#{title},#{content},#{coverImg},#{categoryId},#{state},#{createUser},#{createTime},#{updateTime})")
    void add(Article article);

    // 条件分页查询
    List<Article> list(Integer userId, Integer categoryId, String state);

    // 根据ID查询文章
    @Select("select * from article where id=#{id}")
    Article findById(Integer id);

    // 更新文章
    @Update("update article set title=#{title},content=#{content},cover_img=#{coverImg},state=#{state},category_id=#{categoryId},update_time=#{updateTime} where id=#{id}")
    void update(Article article);

    // 删除文章
    @Delete("delete from article where id=#{id}")
    void delete(Integer id);
}
